﻿CREATE TRIGGER [dbo].[TRG_PAY_IN_ON_SERVICE_UPDATE]
   ON  dbo.PAY_IN_ON_SERVICE
   AFTER INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE PAY_IN_ON_SERVICE
    SET LAST_UPDATE = GETDATE(), 
    LAST_UPDATE_USER = SUSER_NAME()
    WHERE ID IN (SELECT ID FROM INSERTED)
END
